Columns
Grants
Dependencies
Details
Triggers
Errors
Columns
Grants
Dependencies
Details
Triggers
Errors
COLUMN_NAME | DATA_TYPE | NULLABLE | DATA_DEFAULT | COLUMN_ID | COMMENTS | INSERTABLE | UPDATABLE | DELETABLE |
---|---|---|---|---|---|---|---|---|
SID | NUMBER(38) | No | null | 1 | null | NO | NO | NO |
NAME | VARCHAR2(20) | No | null | 2 | null | NO | NO | NO |
LOGIN_ID | VARCHAR2(100) | No | null | 3 | null | NO | NO | NO |
ASSIGNMENT_ID | VARCHAR2(100) | Yes | null | 4 | null | NO | NO | NO |
ASSIGNMENT_TAGLINE | VARCHAR2(400) | Yes | null | 5 | null | NO | NO | NO |
ASSIGNMENT_OBJ_ROOT | VARCHAR2(8) | Yes | null | 6 | null | NO | NO | NO |
ASSIGNMENT_OBJ_TYPE | VARCHAR2(100) | Yes | null | 7 | null | NO | NO | NO |
ASSIGNMENT_OWNING_UNIT | VARCHAR2(400) | Yes | null | 8 | null | NO | NO | NO |
ASSIGNMENT_ROLE | VARCHAR2(100) | Yes | null | 9 | null | NO | NO | NO |
ASSIGNMENT_START_DATE | DATE | No | null | 10 | null | NO | NO | NO |
ASSIGNMENT_END_DATE | DATE | Yes | null | 11 | null | NO | NO | NO |
ASSIGNMENT_STATUS | VARCHAR2(100) | Yes | null | 12 | null | NO | NO | NO |
CREATED_DATE | DATE | Yes | null | 13 | null | NO | NO | NO |
CLOSED_ON | DATE | Yes | null | 14 | null | NO | NO | NO |
CLOSED_ON_FY | NUMBER | Yes | null | 15 | null | NO | NO | NO |
CREATED_ON_FY | NUMBER | Yes | null | 16 | null | NO | NO | NO |
NEXT_DUE_DATE | DATE | Yes | null | 17 | null | NO | NO | NO |
FINAL_DUE_DATE | DATE | Yes | null | 18 | null | NO | NO | NO |
FINAL_DUE_DATE_MET | VARCHAR2(3) | Yes | null | 19 | null | NO | NO | NO |
PRIVILEGE | GRANTEE | GRANTABLE | GRANTOR | OBJECT_NAME |
---|
OWNER | NAME | TYPE | REFERENCED_OWNER | REFERENCED_NAME | REFERENCED_TYPE |
---|
References
NAME | VALUE |
---|---|
CREATED | 11-APR-23 |
LAST_DDL_TIME | 29-FEB-24 |
OWNER | QART |
VIEW_NAME | V_PERSONNEL_ASSIGNMENT_CUBE |
TEXT_LENGTH | 2004 |
TEXT | SELECT DISTINCT SH.SID, O.SID NAME, U.LOGIN_ID, O2.ID ASSIGNMENT_ID, O2.TAGLINE ASSIGNMENT_TAGLINE, DECODE(O2T.OBJ_ROOT, 'ACT', 'Activity', 'FILE', 'File') ASSIGNMENT_OBJ_ROOT, O2T.DISPLAY ASSIGNMENT_OBJ_TYPE, OU.SH_DISPLAY ASSIGNMENT_OWNING_UNIT, SR.DISPLAY ASSIGNMENT_ROLE, SH.START_DATE ASSIGNMENT_START_DATE, SH.END_DATE ASSIGNMENT_END_DATE, S2.DISPLAY ASSIGNMENT_STATUS, O2.CREATED_ON CREATED_DATE, CASE S2.DISPLAY WHEN 'Closed' THEN S.STARTED_ON ELSE NULL END CLOSED_ON, CASE S2.DISPLAY WHEN 'Closed' THEN S.STARTED_ON_FY ELSE NULL END CLOSED_ON_FY, O2.CREATED_ON_FY CREATED_ON_FY, O2.NEXT_DUE_DATE NEXT_DUE_DATE, O2.FINAL_DUE_DATE FINAL_DUE_DATE, CASE WHEN S2.DISPLAY = 'Closed' AND TRUNC(S.STARTED_ON) <= TRUNC(O2.FINAL_DUE_DATE) THEN 'Yes' ELSE 'No' END FINAL_DUE_DATE_MET FROM MV_ACM_STAKEHOLDER SH INNER JOIN MV_ACM_OBJ O ON SH.STAKEHOLDER = O.SID INNER JOIN MV_ACM_USER U ON SH.STAKEHOLDER = U.OBJ LEFT JOIN MV_ACM_OBJ O2 ON SH.OBJ = O2.SID LEFT JOIN MV_ACM_OBJ_TYPE O2T ON O2.OBJ_TYPE = O2T.SID LEFT JOIN V_CURR_OBJ_OWNING_UNIT OU ON SH.OBJ = OU.OBJ LEFT JOIN MV_ACM_STATUS_HISTORY S ON SH.OBJ = S.OBJ AND S.COMPLETED_ON IS NULL LEFT JOIN MV_ACM_STATUS S2 ON S.STATUS = S2.SID LEFT JOIN MV_ACM_STAKEHOLDER_ROLE SR ON SH.SH_ROLE = SR.SID |
TEXT_VC | SELECT DISTINCT SH.SID, O.SID NAME, U.LOGIN_ID, O2.ID ASSIGNMENT_ID, O2.TAGLINE ASSIGNMENT_TAGLINE, DECODE(O2T.OBJ_ROOT, 'ACT', 'Activity', 'FILE', 'File') ASSIGNMENT_OBJ_ROOT, O2T.DISPLAY ASSIGNMENT_OBJ_TYPE, OU.SH_DISPLAY ASSIGNMENT_OWNING_UNIT, SR.DISPLAY ASSIGNMENT_ROLE, SH.START_DATE ASSIGNMENT_START_DATE, SH.END_DATE ASSIGNMENT_END_DATE, S2.DISPLAY ASSIGNMENT_STATUS, O2.CREATED_ON CREATED_DATE, CASE S2.DISPLAY WHEN 'Closed' THEN S.STARTED_ON ELSE NULL END CLOSED_ON, CASE S2.DISPLAY WHEN 'Closed' THEN S.STARTED_ON_FY ELSE NULL END CLOSED_ON_FY, O2.CREATED_ON_FY CREATED_ON_FY, O2.NEXT_DUE_DATE NEXT_DUE_DATE, O2.FINAL_DUE_DATE FINAL_DUE_DATE, CASE WHEN S2.DISPLAY = 'Closed' AND TRUNC(S.STARTED_ON) <= TRUNC(O2.FINAL_DUE_DATE) THEN 'Yes' ELSE 'No' END FINAL_DUE_DATE_MET FROM MV_ACM_STAKEHOLDER SH INNER JOIN MV_ACM_OBJ O ON SH.STAKEHOLDER = O.SID INNER JOIN MV_ACM_USER U ON SH.STAKEHOLDER = U.OBJ LEFT JOIN MV_ACM_OBJ O2 ON SH.OBJ = O2.SID LEFT JOIN MV_ACM_OBJ_TYPE O2T ON O2.OBJ_TYPE = O2T.SID LEFT JOIN V_CURR_OBJ_OWNING_UNIT OU ON SH.OBJ = OU.OBJ LEFT JOIN MV_ACM_STATUS_HISTORY S ON SH.OBJ = S.OBJ AND S.COMPLETED_ON IS NULL LEFT JOIN MV_ACM_STATUS S2 ON S.STATUS = S2.SID LEFT JOIN MV_ACM_STAKEHOLDER_ROLE SR ON SH.SH_ROLE = SR.SID |
TYPE_TEXT_LENGTH | null |
TYPE_TEXT | null |
OID_TEXT_LENGTH | null |
OID_TEXT | null |
VIEW_TYPE_OWNER | null |
VIEW_TYPE | null |
SUPERVIEW_NAME | null |
EDITIONING_VIEW | N |
READ_ONLY | N |
CONTAINER_DATA | N |
BEQUEATH | DEFINER |
ORIGIN_CON_ID | 16 |
DEFAULT_COLLATION | USING_NLS_COMP |
CONTAINERS_DEFAULT | NO |
CONTAINER_MAP | NO |
EXTENDED_DATA_LINK | NO |
EXTENDED_DATA_LINK_MAP | NO |
HAS_SENSITIVE_COLUMN | NO |
ADMIT_NULL | NO |
PDB_LOCAL_ONLY | NO |
DUPLICATED | N |
SHARDED | N |
OWNER | TRIGGER_NAME | TRIGGER_TYPE | TRIGGERING_EVENT | STATUS | OBJECT_ID |
---|
ATTRIBUTE | Line:Position | TEXT |
---|